<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head id="MyHead">
    <script src="../resources/Script/jquery-1.8.3.min.js" type="text/javascript"></script>
    <script src="../resources/Script/JScriptIndex.js" type="text/javascript"></script>
    <script src="../resources/Script/jquery.easyui.min-1.3.5.js" type="text/javascript"></script>
    <link href="../resources/Content/Default.css" rel="stylesheet" type="text/css" />
    <link href="../resources/Content/IndexStyle.css" rel="stylesheet" type="text/css" />
    <link href="../resources/Content/easyui/themes/icon.css" rel="stylesheet" type="text/css" />
    <script src="../resources/Script/easyui-lang-zh_CN.js" type="text/javascript"></script>
    <link href="../resources/css/themes/default/easyui.css" rel="stylesheet" type="text/css" />
    <title>学员状态调整</title>
    <script type="text/javascript" language="javascript">
        $(function () {
             $.extend($.fn.datagrid.methods, {
                 addToolbarItem: function (jq, items) {
                     return jq.each(function () {
                         var dpanel = $(this).datagrid('getPanel');
                         var toolbar = dpanel.children("div.datagrid-toolbar");
                         if (!toolbar.length) {
                             toolbar = $("<div class=\"datagrid-toolbar\"><table cellspacing=\"0\" cellpadding=\"0\"><tr></tr></table></div>").prependTo(dpanel);
                             $(this).datagrid('resize');
                         }
                         var tr = toolbar.find("tr");
                         for (var i = 0; i < items.length; i++) {
                             var btn = items[i];
                             if (btn == "-") {
                                 $("<td><div class=\"datagrid-btn-separator\"></div></td>").appendTo(tr);
                             } else {
                                 var td = $("<td></td>").appendTo(tr);
                                 var b = $("<a href=\"javascript:void(0)\"></a>").appendTo(td);
                                 b[0].onclick = eval(btn.handler || function () { });
                                 b.linkbutton($.extend({}, btn, {
                                     plain: true
                                 }));
                             }
                         }
                     });
                 },
                 removeToolbarItem: function (jq, param) {
                     return jq.each(function () {
                         var dpanel = $(this).datagrid('getPanel');
                         var toolbar = dpanel.children("div.datagrid-toolbar");
                         var cbtn = null;
                         if (typeof param == "number") {
                             cbtn = toolbar.find("td").eq(param).find('span.l-btn-text');
                         } else if (typeof param == "string") {
                             cbtn = toolbar.find("span.l-btn-text:contains('" + param + "')");
                         }
                         if (cbtn && cbtn.length > 0) {
                             cbtn.closest('td').remove();
                             cbtn = null;
                         }
                     });
                 }
             });
         });
    </script>
    
    

    <script type="text/javascript" language="javascript">

        $.extend($.fn.datagrid.defaults.editors, {
            my97: {
                init: function (container, options) {
                    var input = $('<input class="Wdate" onclick="WdatePicker({dateFmt:\'yyyy-MM-dd\',readOnly:true});"  />').appendTo(container);
                    return input;
                },
                getValue: function (target) {
                    return $(target).val();
                },
                setValue: function (target, value) {
                    $(target).val(value);
                },
                resize: function (target, width) {
                    var input = $(target);
                    if ($.boxModel == true) {
                        input.width(width - (input.outerWidth() - input.width()));
                    } else {
                        input.width(width);
                    }
                }
            }
        });


        var schoolNames = [{ id: '0', text: '合格' }, { id: '1', text: '不合格' }, { id: '2', text: '初始值'}];
        var baokaos = [{ id: '0', text: '未报考' }, { id: '2', text: '重新报考' }, { id: '3', text: '报考失败' }, { id: '8', text: '报考成功'}];
        var shoulis = [{ id: '3', text: '未受理' }, { id: '1', text: '受理成功' }, { id: '4', text: '受理失败'}];
        var zhikas = [{ id: '0', text: '待制卡' }, { id: '1', text: '已制卡' }, { id: '2', text: '已发卡'}];

        function getBaokaoID(value) {
            //alert(value);
            for (var i = 0; i < baokaos.length; i++) {
                if (baokaos[i].text == value) {
                    return baokaos[i].id;
                }
            }
            return "";
        }
        function getJieguoID(value) {
            for (var i = 0; i < schoolNames.length; i++) {
                if (schoolNames[i].text == value) return schoolNames[i].id;
            }
            return value;
        }

        function getShouliID(value) {
            for (var i = 0; i < shoulis.length; i++) {
                if (shoulis[i].text == value) return shoulis[i].id;
            }
            return value;
        }

        function getZhikaID(value) {
            for (var i = 0; i < zhikas.length; i++) {
                if (zhikas[i].text == value) return zhikas[i].id;
            }
            return value;
        }

        $(function () {
            $('#flexigridData').datagrid({
                //title: '学员状态调整', //列表的标题
                iconCls: 'icon-site',
                width: 'auto',
                height: 'auto',
                nowrap: true,

                striped: true,
                collapsible: true,
                url: '../../S_Student/GetData', //获取数据的url
                queryParams: { search: 'S_FinanAuditStart_Int&0^S_FinanAuditEnd_Int&0^FK_DIC_Start&noway^' }
                ,
                sortName: 'PK_ID',
                sortOrder: 'desc',
                idField: 'PK_ID',
                onClickRow: onClickRow,
                toolbar: "#toolbar1",
                pagination: true,
                rownumbers: true

            });

        });


        var editIndex = undefined;
        function endEditing() {
            if (editIndex == undefined) { return true }
            if ($('#flexigridData').datagrid('validateRow', editIndex)) {
                $('#flexigridData').datagrid('endEdit', editIndex);
                editIndex = undefined;
                return true;
            } else {
                return false;
            }
        }
        function onClickRow(index) {
            if (editIndex != index) {
                if (endEditing()) {
                    $('#flexigridData').datagrid('selectRow', index)
                            .datagrid('beginEdit', index);
                    editIndex = index;
                } else {
                    $('#flexigridData').datagrid('selectRow', editIndex);
                }
            }
        }
        //内部学员查询
        function FindData() {

            var str = "yes"
            var search = 'S_FinanAuditStart_Int&0^S_FinanAuditEnd_Int&0^FK_DIC_Start&noway^';

            var wordvalue = document.getElementById(str + "wordvalue").value; //关键字

            var S_regdateStart_Time = document.getElementById(str + "S_regdateStart_Time").value; //关键字
            var S_regdateEnd_Time = document.getElementById(str + "S_regdateEnd_Time").value; //关键字

            var searchType = $("#" + str + "searchType").combobox("getValue"); //查询条件

            if (wordvalue != "") {
                search += searchType + "&" + wordvalue + "^"
            }

            if (S_regdateStart_Time != "") {
                search += "S_regdateStart_Time&" + S_regdateStart_Time + "^"
            }
            if (S_regdateEnd_Time != "") {
                search += "S_regdateEnd_Time&" + S_regdateEnd_Time + "^"
            }
            //            if(search!="")
            //            {
            //                search +="FK_DIC_Start&noway^allstu";
            //            }
            //            else
            //            {
            //                search +="FK_DIC_Start&noway^";
            //            }
            //执行查询
            //alert(search);
            $('#flexigridData').datagrid('reload', { search: search + "allstu" });
        }

        //保存修改
        function saveStuYewuState() {

            if (endEditing()) {
                
                //保存修改'getChanges'
                var rows = $('#flexigridData').datagrid('getSelections');
                if (rows.length == 0) {
                    $.messager.alert('操作提示', '请选择数据!', 'warning');
                    return false;
                }

                $('#flexigridData').datagrid('acceptChanges');

                var pkids = [];

                var weizhichu = [];

                var zhika = [];
                var zhikaDate = [];

                var shouli = [];
                var shouliDate = [];

                var sub1BaoKao = [];
                var sub1JieGuo = [];
                var sub1Time = [];

                var sub2BaoKao = [];
                var sub2JieGuo = [];
                var sub2Time = [];

                var sub3BaoKao = [];
                var sub3JieGuo = [];
                var sub3Time = [];

                var sub4BaoKao = [];
                var sub4JieGuo = [];
                var sub4Time = [];

                for (var i = 0; i < rows.length; i++) {
                    pkids.push(rows[i].PK_ID);

                    weizhichu.push(rows[i].S_weizcJine);

                    zhika.push(getZhikaID(rows[i].S_CardStatus));
                    zhikaDate.push(rows[i].S_CardDate);

                    shouli.push(getShouliID(rows[i].S_ZhiDuiShouLi));
                    shouliDate.push(rows[i].S_shuoliriqi);

                    sub1BaoKao.push(getBaokaoID(rows[i].S_Sub1BaoKao));
                    sub1JieGuo.push(getJieguoID(rows[i].S_Sub1JieGuo));
                    sub1Time.push(rows[i].S_Sub1Time);

                    sub2BaoKao.push(getBaokaoID(rows[i].S_Sub2BaoKao));
                    sub2JieGuo.push(getJieguoID(rows[i].S_Sub2JieGuo));
                    sub2Time.push(rows[i].S_Sub2Time);

                    sub3BaoKao.push(getBaokaoID(rows[i].S_Sub3BaoKao));
                    sub3JieGuo.push(getJieguoID(rows[i].S_Sub3JieGuo));
                    sub3Time.push(rows[i].S_Sub3Time);

                    sub4BaoKao.push(getBaokaoID(rows[i].S_Sub4BaoKao));
                    sub4JieGuo.push(getJieguoID(rows[i].S_Sub4JieGuo));
                    sub4Time.push(rows[i].S_Sub4Time);
                }
                //alert(sub2Time.join(','));
                if (rows.length > 0) {
                    $.messager.confirm('操作提示', "确认要保存这 " + rows.length + " 项吗？", function (r) {
                        if (r) {
                            $.post("../../S_Student/saveStuYewuState", {
                                pkids: pkids.join(','),
                                weizhichu:weizhichu.join(','),
                                zhika: zhika.join(','),
                                zhikaDate: zhikaDate.join(','),
                                shouli: shouli.join(','),
                                shouliDate: shouliDate.join(','),
                                sub1BaoKao: sub1BaoKao.join(','),
                                sub1JieGuo: sub1JieGuo.join(','),
                                sub1Time: sub1Time.join(','),
                                sub2BaoKao: sub2BaoKao.join(','),
                                sub2JieGuo: sub2JieGuo.join(','),
                                sub2Time: sub2Time.join(','),
                                sub3BaoKao: sub3BaoKao.join(','),
                                sub3JieGuo: sub3JieGuo.join(','),
                                sub3Time: sub3Time.join(','),
                                sub4BaoKao: sub4BaoKao.join(','),
                                sub4JieGuo: sub4JieGuo.join(','),
                                sub4Time: sub4Time.join(',') 
                                 }, function (res) {
                                if (res == "OK") {
                                    $.messager.alert('系统提示：', '确认保存成功！', 'info');
                                    $("#flexigridData").datagrid("reload");
                                    $("#flexigridData").datagrid("clearSelections");
                                }
                                else {
                                    $.messager.alert('系统提示：', res, 'info');
                                }
                            });
                        }
                    });
                }
            }
        }















        //导入
        function UpFile() {
            var file = document.getElementById('fileUp').value
            var isCreatCost = $("input[name='isCreatCostList']:checked").val();
            if (isCreatCost == undefined || isCreatCost == null) {
                alert("请选择学员流程通过方式！！！");
                return false;
            }
            var scardno = "";
            var kemuyi = "";
            var kemuyiriqi = "";
            var kemuyiweiguo = "";
            var kemuer = "";
            var kemuerriqi = "";
            var kemuerweiguo = "";
            var kemusan = "";
            var kemusanriqi = "";
            var kemusanweiguo = "";
            var kemusi = "";
            var kemusiriqi = "";
            var kemusiweiguo = "";


            var filePath = file;
            var istrue = lastname(file);
            // alert(istrue);
            if (istrue) {
                var oXL = new ActiveXObject("Excel.application");

                var oWB = oXL.Workbooks.open(filePath);
                oWB.worksheets(1).select();
                document.fileform.reset(); //清除
                var oSheet = oWB.ActiveSheet;
                var colcount = oSheet.UsedRange.Cells.Rows.Count; //获取数据行数
                //   var colcolumn = oWB.Worksheets(1).UsedRange.Columns.Count; 获取工作表数量
                // alert(colcount);
                try {

                    for (var i = 3; i <= colcount; i++) {
                        //                        if (oSheet.Cells(i, 1).value == "null" || oSheet.Cells(i, 2).value == "null")
                        //                            break;
                        var a = oSheet.Cells(i, 1).value == undefined ? "novalue" : oSheet.Cells(i, 1).value;  // alert(a);                         
                        var b = oSheet.Cells(i, 2).value == undefined ? "novalue" : oSheet.Cells(i, 2).value; // alert(b);
                        var c = oSheet.Cells(i, 3).value == undefined ? "novalue" : oSheet.Cells(i, 3).value;  // alert(c);
                        var d = oSheet.Cells(i, 4).value == undefined ? "novalue" : oSheet.Cells(i, 4).value;  // alert(d);
                        var f = oSheet.Cells(i, 5).value == undefined ? "novalue" : oSheet.Cells(i, 5).value;  // alert(f);
                        var j = oSheet.Cells(i, 6).value == undefined ? "novalue" : oSheet.Cells(i, 6).value;  // alert(j);
                        var h = oSheet.Cells(i, 7).value == undefined ? "novalue" : oSheet.Cells(i, 7).value;  // alert(h);
                        var ii = oSheet.Cells(i, 8).value == undefined ? "novalue" : oSheet.Cells(i, 8).value;  // alert(ii);
                        var g = oSheet.Cells(i, 9).value == undefined ? "novalue" : oSheet.Cells(i, 9).value;   //alert(g);
                        var k = oSheet.Cells(i, 10).value == undefined ? "novalue" : oSheet.Cells(i, 10).value; //alert(k);
                        var l = oSheet.Cells(i, 11).value == undefined ? "novalue" : oSheet.Cells(i, 11).value; //alert(l);
                        var m = oSheet.Cells(i, 12).value == undefined ? "novalue" : oSheet.Cells(i, 12).value; //alert(m);
                        var n = oSheet.Cells(i, 13).value == undefined ? "novalue" : oSheet.Cells(i, 13).value; //alert(n);


                        scardno += trim(a.toString()) == "" ? "novalue&" : trim(a.toString()) + "&";
                        kemuyi += trim(b.toString()) == "" ? "novalue&" : trim(b.toString()) + "&";
                        kemuyiriqi += trim(c.toString()) == "" ? "novalue&" : trim(c.toString()) + "&";
                        kemuyiweiguo += trim(d.toString()) == "" ? "novalue&" : trim(d.toString()) + "&";
                        kemuer += trim(f.toString()) == "" ? "novalue&" : trim(f.toString()) + "&";
                        kemuerriqi += trim(j.toString()) == "" ? "novalue&" : trim(j.toString()) + "&";
                        kemuerweiguo += trim(h.toString()) == "" ? "novalue&" : trim(h.toString()) + "&";
                        kemusan += trim(ii.toString()) == "" ? "novalue&" : trim(ii.toString()) + "&";


                        kemusanriqi += trim(g.toString()) == "" ? "novalue&" : trim(g.toString()) + "&";
                        kemusanweiguo += trim(k.toString()) == "" ? "novalue&" : trim(k.toString()) + "&";
                        kemusi += trim(l.toString()) == "" ? "novalue&" : trim(l.toString()) + "&";
                        kemusiriqi += trim(m.toString()) == "" ? "novalue&" : trim(m.toString()) + "&";
                        kemusiweiguo += trim(n.toString()) == "" ? "novalue&" : trim(n.toString()) + "&";



                    }
                } catch (e) {


                }

                //                document.all.txtArea.value = scardno;
                //                oXL.Quit();
                //                CollectGarbage();
                //                return false;


                oXL.Quit();
                CollectGarbage();

                if (scardno != "") {
                    progress();
                    $('#upfile').dialog("close");

                    $.post("../../S_Student/ExcelUpdateKaoShi", {
                        scardno: scardno,
                        kemuyi: kemuyi,
                        kemuyiriqi: kemuyiriqi,
                        kemuyiweiguo: kemuyiweiguo,
                        kemuer: kemuer,
                        kemuerriqi: kemuerriqi,
                        kemuerweiguo: kemuerweiguo,
                        kemusan: kemusan,
                        kemusanriqi: kemusanriqi,
                        kemusanweiguo: kemusanweiguo,
                        kemusi: kemusi,
                        kemusiriqi: kemusiriqi,
                        kemusiweiguo: kemusiweiguo,
                        isCreatCost: isCreatCost


                    }, function (res) {

                        if (res.toString().indexOf("NO") <= 0) {
                            $.messager.progress('close');
                            //移除删除的数据
                            document.all.txtAreaUpfileRes.value = res;

                            $("#flexigridData").datagrid("reload");
                            $("#flexigridData").datagrid("clearSelections");
                            $('#upfileMessage').dialog("open");

                        }
                        else {

                            $.messager.progress('close');
                            ocument.all.txtAreaUpfileRes.value = res;
                            $('#upfileMessage').dialog("open");
                            // $.messager.alert('操作提示', '导入失败请核对数据格式', 'info');
                        }
                    });

                } else {
                    $('#upfile').dialog("close");
                    $.messager.alert('操作提示', '导入失败请核对数据格式', 'info');

                }


            }
        };
        function lastname(filepath) {
            //获取欲上传的文件路径

            if (filepath == null || filepath == undefined || filepath == "") {
                alert("请选择要上传的数据模板");
                return false;
            }
            //为了避免转义反斜杠出问题，这里将对其进行转换
            var re = /(\\+)/g;
            var filename = filepath.replace(re, "#");
            //对路径字符串进行剪切截取
            var one = filename.split("#");
            //获取数组中最后一个，即文件名
            var two = one[one.length - 1];
            //再对文件名进行截取，以取得后缀名
            var three = two.split(".");
            //获取截取的最后一个字符串，即为后缀名
            var last = three[three.length - 1];
            //添加需要判断的后缀名类型
            var tp = "xls,xlsx,XLS,XLSX";
            //返回符合条件的后缀名在字符串中的位置
            var rs = tp.indexOf(last);
            //如果返回的结果大于或等于0，说明包含允许上传的文件类型
            if (rs >= 0) {
                return true;
            } else {
                alert("您选择的上传文件不是有效的EXCEL文件！");
                return false;
            }
        }
        function E_AddStuState() {

            $('#upfile').dialog("open");
        };
        function progress() {
            var win = $.messager.progress({
                title: '请等待',
                text: '数据正在处理中'
            });
        }

        function trim(str) { //删除左右两端的空格 
            return str.replace(/(^\s*)|(\s*$)/g, "");
        }

        //以上是 导入功能
        function openEXCEL() {

            $('#upfile').dialog('open');
        
        }

    </script>

<script src="/Res/My97DatePicker/WdatePicker.js" type="text/javascript"></script>

      <base target = "_self">
</head>
<body>
    
   <div class="easyui-panel" fit="true" style="margin:5px;" border="false">
   <table class="easyui-datagrid" id="flexigridData" data-options="fit:true">
       

       <thead data-options="frozen:true">
           <tr>
                <th data-options="field:'ck',width:30,checkbox: true" rowspan="2"></th>
                <th data-options="field:'S_NO',width:70,sortable:true" rowspan="2"><label for="S_NO">学员编号</label></th>
               <th data-options="field:'S_ArNO',width:80,sortable:true" rowspan="2"><label for="S_ArNO">档案编号</label></th>
               <th data-options="field:'S_name',width:60,sortable:true" rowspan="2"><label for="S_name">姓名</label></th>
               <th data-options="field:'S_sex',width:40,align:'center',sortable:true" rowspan="2"><label for="S_sex">性别</label></th>
               
           </tr>
        </thead>

        <thead>
            <tr>
                
                
                <th colspan="2">支队受理</th>
                <th colspan="3">科目一理论</th>
                <th colspan="3">科目二</th>
                <th colspan="3">科目三</th>
                <th colspan="3">科目三理论</th>
           </tr>
           <tr>


                <th data-options="field:'S_ZhiDuiShouLi',width:60,align:'center',editor: {type: 'combobox',options: {
                                valueField: 'text',
                                textField: 'text',
                                data: shoulis,
                                panelHeight: 'auto'
                            }
                        },sortable:true">受理状态</th>
                <th data-options="field:'S_shuoliriqi',width:76,align:'center',editor: {type:'my97'},sortable:true">受理日期</th>
                <th data-options="field:'S_Sub1BaoKao',width:60,align:'center',editor: {type: 'combobox',options: {
                                valueField: 'text',
                                textField: 'text',
                                data: baokaos,
                                panelHeight: 'auto'
                            }
                        },sortable:true">报考状态</th>
                <th data-options="field:'S_Sub1JieGuo',width:60,align:'center',editor: {type: 'combobox',options: {
                                valueField: 'text',
                                textField: 'text',
                                data: schoolNames,
                                panelHeight: 'auto'
                            }
                        },sortable:true">考试结果</th>
                <th data-options="field:'S_Sub1Time',width:80,align:'center',editor: {type:'my97'},sortable:true">考试日期</th>

                <th data-options="field:'S_Sub2BaoKao',width:60,align:'center',editor: {type: 'combobox',options: {
                                valueField: 'text',
                                textField: 'text',
                                data: baokaos,
                                panelHeight: 'auto'
                            }
                        },sortable:true">报考状态</th>
                <th data-options="field:'S_Sub2JieGuo',width:60,align:'center',editor: {type: 'combobox',options: {
                                valueField: 'text',
                                textField: 'text',
                                data: schoolNames,
                                panelHeight: 'auto'
                            }
                        },sortable:true">考试结果</th>
                <th data-options="field:'S_Sub2Time',width:80,align:'center',editor: {type:'my97'},sortable:true">考试日期</th>

                <th data-options="field:'S_Sub3BaoKao',width:60,align:'center',editor: {type: 'combobox',options: {
                                valueField: 'text',
                                textField: 'text',
                                data: baokaos,
                                panelHeight: 'auto'
                            }
                        },sortable:true">报考状态</th>
                <th data-options="field:'S_Sub3JieGuo',width:60,align:'center',editor: {type: 'combobox',options: {
                                valueField: 'text',
                                textField: 'text',
                                data: schoolNames,
                                panelHeight: 'auto'
                            }
                        },sortable:true">考试结果</th>
                <th data-options="field:'S_Sub3Time',width:80,align:'center',editor: {type:'my97'},sortable:true">考试日期</th>

                <th data-options="field:'S_Sub4BaoKao',width:60,align:'center',editor: {type: 'combobox',options: {
                                valueField: 'text',
                                textField: 'text',
                                data: baokaos,
                                panelHeight: 'auto'
                            }
                        },sortable:true">报考状态</th>
                <th data-options="field:'S_Sub4JieGuo',width:60,align:'center',editor: {type: 'combobox',options: {
                                valueField: 'text',
                                textField: 'text',
                                data: schoolNames,
                                panelHeight: 'auto'
                            }
                        },sortable:true">考试结果</th>
                <th data-options="field:'S_Sub4Time',width:80,align:'center',editor: {type:'my97'},sortable:true">考试日期</th>
                
            </tr>
        </thead>
    </table>
    </div>
        <div id="toolbar1" style="padding:5px;height:auto; font-size:12px;">
        <div style="margin-bottom:5px">
            <a href="#" class="easyui-linkbutton" iconCls="icon-save" onclick='saveStuYewuState();' plain="true">保存修改</a>
        </div>
        <div>
         查询条件：
            <select class="easyui-combobox" panelHeight="auto" id="yessearchType" style="width:100px">
                <option value="S_cardno">身份证号</option>
                <option value="S_zhunkaoCode">准考证号</option>
                <option value="S_ArNO">档案编号</option>
                <option value="S_NO">学员编号</option>
                <option value="S_name">学员姓名</option>
                <option value="S_mob">手机号码</option>
           </select>&nbsp;
            关键字: <input class="input-textbox" id="yeswordvalue" style="width:80px" />&nbsp;&nbsp;
            报名日期：&nbsp;<input type="text" class="input-textbox" width="60" id="yesS_regdateStart_Time" onclick="WdatePicker({maxDate:'#F{$dp.$D(\'yesS_regdateEnd_Time\');}'})"  />
             <span>到</span>
             <input type="text" class="input-textbox" width="60" id="yesS_regdateEnd_Time" onclick="WdatePicker({minDate:'#F{$dp.$D(\'yesS_regdateStart_Time\');}'})" />
           <a href="javascript:void(0);" onclick="FindData();" class="easyui-linkbutton" iconCls="icon-search">查询</a>
             <a href="javascript:void(0);" onclick="openEXCEL();" class="easyui-linkbutton" iconCls="icon-excel">导入EXCEL</a>
        </div>
    </div>
     
         <div id="upfile" title="文件上传" class="easyui-dialog" closed="true" modal="true" iconcls="icon-search" style="width:500px; height:230px; text-align:center;">
          <p></p>
          <form name="fileform">
          <input type="file" id="fileUp" name="fileUp" size="23" />
           <a href="javascript:void(0);" onclick="UpFile();" class="easyui-linkbutton" iconCls="icon-ok">上传</a>
           <p></p>
             
            <span  style=" text-align:center;">学员状态数据导入涉及重要数据请慎重操作！只有录入系统的学员才能进行此操作！</span>
            <p></p>              
            <span  style=" text-align:center;">如选择只通过科目一前流程，将不导入任何考试成绩但学员科一之前流程自动通过</span>  
            <p></p>  
            <span  style=" text-align:center;">如选择按考试信息通过流程，自动根据考试状况通过必走流程并导入相应科目成绩</span>  
            <p></p>        
            只通过科一前流程:<span class="right"><input type="radio" name="isCreatCostList" value="notongbu" /></span>&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;
            按考试信息通过流程:<span class="right"><input type="radio" name="isCreatCostList" value="yestongbu" /></span>&nbsp; 
          </form>
         
          
         </div>

         <div id="upfileMessage" title="文件上传结果" class="easyui-dialog" closed="true" modal="true" iconcls="icon-search" style="width:600px; height:400px; text-align:center;">
           <p></p><textarea name="txtAreaUpfileRes" cols="60" rows="20" style="font-weight:bold; color:#333;background-color:#FFFFFF; " disabled="disabled"></textarea>
         </div>
</body>
</html>
